object PerformansTeknikServisF: TPerformansTeknikServisF
  Left = 348
  Top = 42
  Width = 784
  Height = 621
  Caption = 'Teknik Servis Personel Performans Grafi'#287'i'
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  KeyPreview = True
  OldCreateOrder = False
  WindowState = wsMaximized
  OnClose = FormClose
  OnKeyPress = FormKeyPress
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object DBChart1: TDBChart
    Left = 0
    Top = 0
    Width = 776
    Height = 473
    BackWall.Brush.Color = clWhite
    BackWall.Brush.Style = bsClear
    Title.Text.Strings = (
      'Teknik Servis Personel Performans Grafi'#287'i [Son 5 Hafta] '
      '(Veriler Onar'#305'm Biti'#351' Tarihine G'#246're Hesaplat'#305'lmaktad'#305'r.)')
    Legend.TextStyle = ltsPlain
    ScaleLastPage = False
    Align = alClient
    TabOrder = 0
    object Series1: TBarSeries
      Marks.ArrowLength = 20
      Marks.Clip = True
      Marks.Style = smsValue
      Marks.Visible = True
      DataSource = Performans2Q
      SeriesColor = clRed
      XLabelsSource = 'tamireden'
      XValues.DateTime = False
      XValues.Name = 'X'
      XValues.Multiplier = 1.000000000000000000
      XValues.Order = loAscending
      XValues.ValueSource = 'sayi'
      YValues.DateTime = False
      YValues.Name = 'Bar'
      YValues.Multiplier = 1.000000000000000000
      YValues.Order = loNone
      YValues.ValueSource = 'sayi'
    end
  end
  object GroupBox1: TGroupBox
    Left = 0
    Top = 473
    Width = 776
    Height = 121
    Align = alBottom
    Caption = #304'statiksel Veriler'
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 1
    object Label2: TLabel
      Left = 135
      Top = 65
      Width = 55
      Height = 14
      Caption = '[ 54 ] Adet'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlue
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Label1: TLabel
      Left = 135
      Top = 49
      Width = 60
      Height = 14
      Caption = '[ 4.52 ] G'#252'n'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clMaroon
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Label3: TLabel
      Left = 135
      Top = 81
      Width = 61
      Height = 14
      AutoSize = False
      Caption = '[ 107 ] Adet'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clMaroon
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Label4: TLabel
      Left = 254
      Top = 81
      Width = 61
      Height = 14
      AutoSize = False
      Caption = '[ 107 ] Adet'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clMaroon
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Label7: TLabel
      Left = 137
      Top = 99
      Width = 55
      Height = 14
      Caption = '[ 54 ] Adet'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlue
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Label5: TLabel
      Left = 390
      Top = 81
      Width = 62
      Height = 14
      AutoSize = False
      Caption = '[ 107 ] Adet'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clMaroon
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Label6: TLabel
      Left = 529
      Top = 81
      Width = 61
      Height = 14
      AutoSize = False
      Caption = '[ 107 ] Adet'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlue
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Panel1: TPanel
      Left = 658
      Top = 16
      Width = 116
      Height = 103
      Align = alRight
      BevelOuter = bvNone
      TabOrder = 1
      object BitBtn2: TBitBtn
        Left = 5
        Top = 74
        Width = 52
        Height = 23
        Caption = 'Yazd'#305'r'
        TabOrder = 0
        OnClick = BitBtn2Click
      end
      object BitBtn1: TBitBtn
        Left = 61
        Top = 74
        Width = 52
        Height = 23
        Caption = 'Kapat'
        TabOrder = 1
        OnClick = BitBtn1Click
      end
    end
    object ToplamBilgik: TStaticText
      Left = 133
      Top = 20
      Width = 879
      Height = 30
      AutoSize = False
      Caption = 'Ekrem T'#252'fek'#231'i [213], Sava'#351' Ar'#305' [100]'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlue
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 0
    end
    object StaticText1: TStaticText
      Left = 11
      Top = 20
      Width = 122
      Height = 18
      Caption = 'Toplam Onar'#305'lan '#220'r'#252'n    :'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 2
    end
    object StaticText2: TStaticText
      Left = 11
      Top = 65
      Width = 122
      Height = 18
      Caption = 'G'#252'nl'#252'k Ortama Adet      :'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 3
    end
    object StaticText3: TStaticText
      Left = 11
      Top = 50
      Width = 122
      Height = 18
      Caption = #220'r'#252'n'#252'n Bekleyi'#351' S'#252'resi :'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 4
    end
    object StaticText4: TStaticText
      Left = 12
      Top = 82
      Width = 121
      Height = 18
      Caption = 'Bekleyen '#220'r'#252'n Say'#305's'#305'    :'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 5
    end
    object StaticText5: TStaticText
      Left = 203
      Top = 65
      Width = 315
      Height = 18
      Caption = '( Ge'#231'mi'#351' Haftaki Verilere G'#246're G'#252'nl'#252'k Tamamlanan '#220'r'#252'n Say'#305's'#305' )'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 6
    end
    object StaticText6: TStaticText
      Left = 203
      Top = 49
      Width = 417
      Height = 18
      Caption = 
        '( Son 3 Ayl'#305'k Verilere G'#246're Bir '#220'r'#252'n'#252'n Teknik Servise Geli'#351' ve '#199 +
        #305'k'#305#351' Tarihi Ortalamas'#305' )'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 7
    end
    object StaticText8: TStaticText
      Left = 203
      Top = 81
      Width = 47
      Height = 18
      AutoSize = False
      Caption = '( S'#305'rada ) '
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 8
    end
    object StaticText7: TStaticText
      Left = 455
      Top = 81
      Width = 66
      Height = 18
      AutoSize = False
      Caption = '( Onar'#305'mda ) '
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 9
    end
    object StaticText9: TStaticText
      Left = 11
      Top = 99
      Width = 121
      Height = 18
      Caption = '15 G'#252'n'#252' Ge'#231'en '#220'r'#252'n    :'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 10
    end
    object StaticText10: TStaticText
      Left = 203
      Top = 97
      Width = 351
      Height = 18
      Caption = 
        '( 15 G'#252'n'#252' Ge'#231'ip Halen Daha Onar'#305'm A'#351'amas'#305'nda Bulunan '#220'r'#252'n Say'#305's'#305 +
        ' ) '
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 11
    end
    object StaticText11: TStaticText
      Left = 319
      Top = 81
      Width = 67
      Height = 18
      AutoSize = False
      Caption = '( D'#305#351' Takipte ) '
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 12
    end
    object StaticText12: TStaticText
      Left = 593
      Top = 81
      Width = 55
      Height = 18
      AutoSize = False
      Caption = '( Toplam ) '
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 13
    end
  end
  object PerformansQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'tipi'
        DataType = ftInteger
        Size = 1
        Value = 4
      end>
    SQL.Strings = (
      
        'select teslimtarihi=(select max(bittarih) from onarim where onar' +
        'im.formno=teknik.formno),tamireden=(select max(tamireden) from o' +
        'narim where onarim.formno=teknik.formno) into #yeni from teknik'
      
        'where (select max(bittarih) from onarim where onarim.formno=tekn' +
        'ik.formno)>=(getdate()-35) and (durumu='#39'T'#39' or durumu='#39'G'#39') and ti' +
        'pi=:tipi and carikodgir<>12810'
      'order by teslimtarihi'
      ''
      ''
      
        'select DATEDIFF(ww,teslimtarihi,getdate()) as hafta,dbo.getperso' +
        'nel(tamireden) as tamireden,count(*) as sayi from #yeni'
      'group by DATEDIFF(ww,teslimtarihi,getdate()),tamireden'
      'having DATEDIFF(ww,teslimtarihi,getdate())<5'
      'order by hafta desc,tamireden asc'
      ''
      'drop table #yeni')
    Left = 152
    Top = 40
  end
  object Performans2Q: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'tipi'
        DataType = ftInteger
        Size = 1
        Value = 4
      end>
    SQL.Strings = (
      
        'select teslimtarihi=(select max(bittarih) from onarim where onar' +
        'im.formno=teknik.formno),tamireden=(select max(tamireden) from o' +
        'narim where onarim.formno=teknik.formno) into #yeni from teknik'
      
        'where (select max(bittarih) from onarim where onarim.formno=tekn' +
        'ik.formno)>=(getdate()-35) and (durumu='#39'T'#39' or durumu='#39'G'#39') and ti' +
        'pi=:tipi and carikodgir<>12810'
      'order by teslimtarihi'
      ''
      ''
      
        'select DATEDIFF(ww,teslimtarihi,getdate()) as hafta,dbo.getperso' +
        'nel(tamireden) as tamireden,count(*) as sayi into #yeni2 from #y' +
        'eni'
      'group by DATEDIFF(ww,teslimtarihi,getdate()),tamireden'
      'having DATEDIFF(ww,teslimtarihi,getdate())<5'
      'order by hafta desc,tamireden asc'
      ''
      'select tamireden,sum(sayi) as sayi from #yeni2'
      'group by tamireden'
      'order by sayi'
      ''
      'drop table #yeni'
      'drop table #yeni2')
    Left = 152
    Top = 88
  end
  object islemQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'tipi'
        DataType = ftInteger
        Size = 1
        Value = 4
      end>
    SQL.Strings = (
      
        'select teslimtarihi,tamireden=(select max(tamireden) from onarim' +
        ' where onarim.formno=teknik.formno) into #yeni from teknik'
      
        'where teslimtarihi>=(getdate()-35) and durumu='#39'G'#39' and tipi=:tipi' +
        ' and carikodgir<>12810'
      'order by formno'
      ''
      
        'select DATEDIFF(ww,teslimtarihi,getdate()) as hafta,dbo.getperso' +
        'nel(tamireden) as tamireden,count(*) as sayi into #yeni2 from #y' +
        'eni'
      'group by DATEDIFF(ww,teslimtarihi,getdate()),tamireden'
      'having DATEDIFF(ww,teslimtarihi,getdate())<5'
      'order by hafta desc,tamireden asc'
      ''
      'select tamireden,sum(sayi) as sayi from #yeni2'
      'group by tamireden'
      'order by sayi'
      ''
      'drop table #yeni'
      'drop table #yeni2')
    Left = 152
    Top = 128
  end
  object ADOQuery1: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'tipi'
        DataType = ftInteger
        Size = 1
        Value = 4
      end>
    SQL.Strings = (
      
        'select teslimtarihi,tamireden=(select max(tamireden) from onarim' +
        ' where onarim.formno=teknik.formno) into #yeni from teknik'
      
        'where teslimtarihi>=(getdate()-35) and durumu='#39'G'#39' and tipi=:tipi' +
        ' and carikodgir<>12810'
      'order by formno'
      ''
      ''
      
        'select DATEDIFF(ww,teslimtarihi,getdate()) as hafta,dbo.getperso' +
        'nel(tamireden) as tamireden,count(*) as sayi from #yeni'
      'group by DATEDIFF(ww,teslimtarihi,getdate()),tamireden'
      'having DATEDIFF(ww,teslimtarihi,getdate())<5'
      'order by hafta desc,tamireden asc'
      ''
      'drop table #yeni')
    Left = 408
    Top = 48
  end
  object ADOQuery2: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'tipi'
        DataType = ftInteger
        Size = 1
        Value = 4
      end>
    SQL.Strings = (
      
        'select teslimtarihi,tamireden=(select max(tamireden) from onarim' +
        ' where onarim.formno=teknik.formno) into #yeni from teknik'
      
        'where teslimtarihi>=(getdate()-35) and durumu='#39'G'#39' and tipi=:tipi' +
        ' and carikodgir<>12810'
      'order by formno'
      ''
      
        'select DATEDIFF(ww,teslimtarihi,getdate()) as hafta,dbo.getperso' +
        'nel(tamireden) as tamireden,count(*) as sayi into #yeni2 from #y' +
        'eni'
      'group by DATEDIFF(ww,teslimtarihi,getdate()),tamireden'
      'having DATEDIFF(ww,teslimtarihi,getdate())<5'
      'order by hafta desc,tamireden asc'
      ''
      'select tamireden,sum(sayi) as sayi from #yeni2'
      'group by tamireden'
      'order by sayi'
      ''
      'drop table #yeni'
      'drop table #yeni2'
      '')
    Left = 408
    Top = 96
  end
end
